Client Fee Expense Details

This section shows details of all client fee expenses for the period and can be viewed by Financial Advisors and Broker Masters only.

This section appears in the Default Statement and Activity Flex Query Reference. All fields that are italicized are only populated in the Consolidated option report.

Column	Description
Account ID	The account number.
Account Alias	Account alias, if there is one.
Model	Model, if applicable.
Currency	The currency denomination of the client fee.
FX Rate to Base	The conversion rate from asset currency to base currency.
Date/Time	Date and time of the fee expense.
Revenue	Amount of commission received from the client.
Trade ID	Trade ID.
Exec ID	Execution ID of the transaction.
Total Commission	The amount of commission.
Broker Execution Charge	Broker execution fee.
Clearing Charge	Clearing charges.
Third-Party Execution Charge	Third-party execution fee.
Third-Party Regulatory Charge	Third-party regulatory fee.
Other	Other fee expenses.
Net	Net amount received after expenses have been paid.
Net/Base	Net amount received after expenses have been paid, converted to your base currency.
Asset Class	The asset class of the instrument traded.
Symbol	The symbol of the instrument traded.
Description	The name of the instrument traded.
Underlying Symbol	The underlying symbol of the instrument traded.
Multiplier	Security or contract size.
Expiration	The expiration of the contract if applicable.
Strike	The strike price of the contract if applicable.
Put/Call	Put or Call.
Security ID	The security ID of the instrument traded.
Underlying Security ID	The underlying security ID of the instrument traded.
Settle Date	The settle date of the trade.
Trade Price	The transaction price.
Buy/Sell	Buy or sell.
Quantity	The number of units traded.
Proceeds	Calculated by multiplying the quantity and trade price. The proceeds figure will be negative for buys and positive for sells.